Returns or sets a location (within the document) associated with the hyperlink (the string to the right of the # symbol in the hyperlink address). Read/write String.
expression.SubAddress
expression Required. An expression that returns one of the objects in the Applies To list.
This example sets the address and subaddress for the specified hyperlink.
Sub SetHyperlink()
Dim hypHyperlink
Set hypHyperlink = Spreadsheet1.Range("A12").Hyperlink
hypHyperlink.Address = "http://example.microsoft.com/ExcelDev/e-tips.htm"
hypHyperlink.Subaddress = "top"
End Sub